Jennifer Kurtz
Jennifer Kurtz
Reactions
-
Re: Pull value from cell to a new cell, and it won't change even if source value changes
Hi there- One idea is that you could create a "Copy Row" automation in the Team Employees sheet that would run any time the # of Employees column changes. You could copy the row to the Logi…1 · -
Re: Help to identify all x.x.1 cells
Hi, @melmcdtsp — I think you could use the RIGHT function to identify the x.x.1 rows, as I think "1" would always be the rightmost number. For example a column with this formula, =IF(RIGHT(…1 · -
Re: Need an equation to count text from a column with multiple selections
Hi @shyannroddy ! Is the column you want to count a multi-select drop down? If so, try HAS in your criteria — e.g., =COUNTIF({Range3}, HAS(@cell, "Paint")) If the column you want to count i…1 · -
Re: Can I automate what lane a card in the dashboard is in based on filling out another linked sheet?
It sounds like you've put a sheet on the dashboard with the Card View - is that right? If so, you can use a formula to calculate the status (e.g., when tasks 1, 2, and 3 are done). That will update t…1 · -
Re: Can I make the image not downloadable when I click twice?
I don't believe there's a way to do exactly what you're asking. A possible workaround: the image could be stored in another sheet & linked in, and then share the sheet with the linked image as vi…1 ·
